﻿<?xml version="1.0"?>
<CsvDataLoaderParams xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <TableMetadataEntity>
    <Name>Building Permits</Name>
    <Category>Infrastructure</Category>
    <Description>This dataset provides information on building permits granted by the Department of Consumer and Regulatory Affairs (DCRA)</Description>
    <Source>DC Department of Consumer and Regulatory Affairs </Source>
    <LastUpdateDate>2009-03-29T00:00:00</LastUpdateDate>
    <MetadataUrl>http://data.octo.dc.gov/Metadata.aspx?id=5</MetadataUrl>
    <EntitySet>BuildingPermits</EntitySet>
    <EntityKind>BuildingPermit</EntityKind>
  </TableMetadataEntity>
  <ProducerParams>
    <PlacemarkParams>
      <LatitudeProperty>LATITUDE</LatitudeProperty>
      <LongitudeProperty>LONGITUDE</LongitudeProperty>
      <NamePropertyFormatString>Type: {0} Subtype: {1} Applicant: {2} Status: {3} Issued: {4} Id: {5}</NamePropertyFormatString>
      <NameProperties>
        <string>PERMIT_TYPE_NAME</string>
        <string>PERMIT_SUBTYPE_NAME</string>
        <string>PERMIT_APPLICANT</string>
        <string>APPLICATION_STATUS_NAME</string>
        <string>ISSUE_DATE</string>
        <string>PERMIT_ID</string>
      </NameProperties>
    </PlacemarkParams>
    <PropertyToTypeMap>
      <DCRAINTERNALNUMBER>string</DCRAINTERNALNUMBER>
      <ISSUE_DATE>DateTime</ISSUE_DATE>
      <PERMIT_ID>string</PERMIT_ID>
      <PERMIT_TYPE_NAME>string</PERMIT_TYPE_NAME>
      <PERMIT_SUBTYPE_NAME>string</PERMIT_SUBTYPE_NAME>
      <PERMIT_CATEGORY_NAME>string</PERMIT_CATEGORY_NAME>
      <APPLICATION_STATUS_NAME>string</APPLICATION_STATUS_NAME>
      <FULL_ADDRESS>string</FULL_ADDRESS>
      <DESC_OF_WORK>string</DESC_OF_WORK>
      <SSL>string</SSL>
      <ZONING>string</ZONING>
      <PERMIT_APPLICANT>string</PERMIT_APPLICANT>
      <FEE_TYPE>string</FEE_TYPE>
      <FEES_PAID>Int32</FEES_PAID>
      <OWNER_NAME>string</OWNER_NAME>
      <LASTMODIFIEDDATE>DateTime</LASTMODIFIEDDATE>
      <CITY>string</CITY>
      <STATE>string</STATE>
      <LATITUDE>double</LATITUDE>
      <LONGITUDE>double</LONGITUDE>
      <ZIPCODE>string</ZIPCODE>
      <MARADDRESSREPOSITORYID>string</MARADDRESSREPOSITORYID>
      <DCSTATADDRESSKEY>string</DCSTATADDRESSKEY>
      <DCSTATLOCATIONKEY>string</DCSTATLOCATIONKEY>
      <WARD>string</WARD>
      <ANC>string</ANC>
      <SMD>string</SMD>
      <DISTRICT>string</DISTRICT>
      <PSA>string</PSA>
      <NEIGHBORHOODCLUSTER>string</NEIGHBORHOODCLUSTER>
      <HOTSPOT2006NAME>string</HOTSPOT2006NAME>
      <HOTSPOT2005NAME>string</HOTSPOT2005NAME>
      <HOTSPOT2004NAME>string</HOTSPOT2004NAME>
      <BUSINESSIMPROVEMENTDISTRICT>string</BUSINESSIMPROVEMENTDISTRICT>
    </PropertyToTypeMap>
  </ProducerParams>
  <ProcessorParams>
    <PartitionKeyPropertyName>PERMIT_APPLICANT</PartitionKeyPropertyName>
    <RowKeyPropertyName>PERMIT_ID</RowKeyPropertyName>
    <TableMetadataPartitionKeyPropertyName>Name</TableMetadataPartitionKeyPropertyName>
    <TableMetadataRowKeyPropertyName>New.Guid</TableMetadataRowKeyPropertyName>
    <EntityMetadataPartitionKeyPropertyName>EntitySet</EntityMetadataPartitionKeyPropertyName>
    <EntityMetadataRowKeyPropertyName>EntityKind</EntityMetadataRowKeyPropertyName>
  </ProcessorParams>
</CsvDataLoaderParams>